<?php
/**
 * Prado Portal.
 *
 * @author Steen Rabol <steen.rabol@gmail.com>
 * @link http://www.pradoportal.dk/
 * @copyright Copyright &copy; 2006,2007,2008 Steen Rabol
 * @license http://www.pradoportal.dk
 * @version $Id: MySQL.php 461 2011-01-16 18:04:56Z steen.rabol $
 *
 */

$drop_table[] = "DROP TABLE IF EXISTS tblnewsletter";
$create_table[] = "CREATE TABLE IF NOT EXISTS tblnewsletter (
  id int(11) NOT NULL AUTO_INCREMENT,
  name varchar(36) NOT NULL,
  sent int(11) DEFAULT NULL,
  sentdate int(11) DEFAULT NULL,
  sentcount int(11) DEFAULT NULL,
  subject varchar(128) DEFAULT NULL,
  body text,
  PRIMARY KEY (id)
)";

$drop_table[] = "DROP TABLE IF EXISTS tblnewsletteruser";
$create_table[] = "CREATE TABLE IF NOT EXISTS tblnewsletteruser (
  id int(11) NOT NULL AUTO_INCREMENT,
  email varchar(128) NOT NULL,
  PRIMARY KEY (id)
)";

?>